/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Modulo4;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.json.*;
import java.io.PrintWriter;
import Modelo.DAL.ConexionBD;
import Modelo.DAL.Guardia_DAO;
import Acceso.Security;
import java.sql.*;

/**
 *
 * @author yngrdyn
 */
public class consultarCambioGuardiaAction extends org.apache.struts.action.Action {
    
    /* forward name="success" path="" */
    private static final String SUCCESS = "success";
    
    /**
     * This is the action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     * @throws java.lang.Exception
     * @return
     */
    @Override
    public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {

        String[] a = {"Administrador","Director DSI","Jefe Apoyo Administrativo"};
       if (!Security.validateSession(request, a)) {
            return mapping.findForward("errorPriv");
        }
        System.out.println("Paso Autenticación");
        
        //consultarAsistenciaForm formBean = (consultarAsistenciaForm)form;
        //String ci = formBean.getCi();
        String ci = request.getParameter("ci");
        String fechaD = request.getParameter("fechaDesde");
        String fechaH = request.getParameter("fechaHasta");
        String sede = request.getParameter("sede");
        String voe = request.getParameter("voe");

        String CIcompuesta = "";
        if (ci != null && !ci.isEmpty()){
            CIcompuesta = voe + "-" + ci;
        }

        response.setContentType("text/json");
        JSONObject data = new JSONObject();
        System.out.println("\n\n\nEntra al action");
        Guardia_DAO asist = new Guardia_DAO();
        data.put("listaCambiosGuardia", asist.consultarCambiosGuardia(fechaD,fechaH,ci,sede));
        PrintWriter pw = response.getWriter();
        pw.write(data.toString());
        pw.flush();
        pw.close();

        return mapping.findForward(SUCCESS);
    }
}
